datasets <- data.frame(
Type=c("Aspatial",
"Geospatial",
"Geospatial - Extracted",
"Geospatial",
"Geospatial",
"Geospatial",
"Geospatial",
"Geospatial - Extracted",
"Geospatial - Extracted",
"Geospatial - Extracted",
"Geospatial - Extracted",
"Geospatial",
"Geospatial",
"Geospatial"
),
Name=c("Resale Flat Prices",
"Master Plan 2019 Subzone Boundary (Web)",
"Central Business District Coordinates",
"Eldercare Services",
"Hawker Centres",
"MRT Stations",
"Parks",
"Good Primary Schools",
"Shopping Mall",
"Supermarkets",
"Kindergartens",
"Childcare Services",
"Bus Stops",
"Primary Schools"),
Format=c(".csv",
".shp",
".shp",
".shp",
".geojson",
".shp",
".kml",
".shp",
".geojson",
".geojson",
".shp",
".geojson",
".shp",
".xlsx"
),
Source=c("[data.gov.sg](https://data.gov.sg/dataset/resale-flat-prices)",
"[In-Class Ex 9](https://data.gov.sg/dataset/master-plan-2019-subzone-boundary-no-sea)",
"[latlong.net](https://www.latlong.net/place/downtown-core-singapore-20616.html)",
"[data.gov.sg](https://data.gov.sg/dataset/eldercare-services)",
"[data.gov.sg](https://data.gov.sg/dataset/hawker-centres)",
"[Datamall](https://datamall.lta.gov.sg/content/dam/datamall/datasets/Geospatial/TrainStationExit.zip)",
"[data.gov.sg](https://data.gov.sg/dataset/parks)",
"[salary.sg](https://www.salary.sg/2022/best-primary-schools-2022-by-popularity/)",
"[Mall SVY21 Coordinates Web Scaper](https://github.com/ValaryLim/Mall-Coordinates-Web-Scraper)",
"[data.gov.sg](https://data.gov.sg/dataset/supermarkets)",
"[OneMap API](https://www.onemap.gov.sg/docs/)",
"[Hands-on Ex 3](https://annatrw-is415.netlify.app/hands-on_ex/hands-on_ex03/hands-on_ex03)",
"[Datamall](https://datamall.lta.gov.sg/content/dam/datamall/datasets/Geospatial/BusStopLocation.zip)",
"[data.gov.sg](https://data.gov.sg/dataset/school-directory-and-information)"
)
)
# with reference to this guide on kableExtra:
# https://cran.r-project.org/web/packages/kableExtra/vignettes/awesome_table_in_html.html
# kable_material is the name of the kable theme
# 'hover' for to highlight row when hovering, 'scale_down' to adjust table to fit page width
library(knitr)
library(kableExtra)
kable(datasets, caption="Datasets Used") %>%
kable_material("hover", latex_options="scale_down")| Type | Name | Format | Source |
|---|---|---|---|
| Aspatial | Resale Flat Prices | .csv | [data.gov.sg](https://data.gov.sg/dataset/resale-flat-prices) |
| Geospatial | Master Plan 2019 Subzone Boundary (Web) | .shp | [In-Class Ex 9](https://data.gov.sg/dataset/master-plan-2019-subzone-boundary-no-sea) |
| Geospatial - Extracted | Central Business District Coordinates | .shp | [latlong.net](https://www.latlong.net/place/downtown-core-singapore-20616.html) |
| Geospatial | Eldercare Services | .shp | [data.gov.sg](https://data.gov.sg/dataset/eldercare-services) |
| Geospatial | Hawker Centres | .geojson | [data.gov.sg](https://data.gov.sg/dataset/hawker-centres) |
| Geospatial | MRT Stations | .shp | [Datamall](https://datamall.lta.gov.sg/content/dam/datamall/datasets/Geospatial/TrainStationExit.zip) |
| Geospatial | Parks | .kml | [data.gov.sg](https://data.gov.sg/dataset/parks) |
| Geospatial - Extracted | Good Primary Schools | .shp | [salary.sg](https://www.salary.sg/2022/best-primary-schools-2022-by-popularity/) |
| Geospatial - Extracted | Shopping Mall | .geojson | [Mall SVY21 Coordinates Web Scaper](https://github.com/ValaryLim/Mall-Coordinates-Web-Scraper) |
| Geospatial - Extracted | Supermarkets | .geojson | [data.gov.sg](https://data.gov.sg/dataset/supermarkets) |
| Geospatial - Extracted | Kindergartens | .shp | [OneMap API](https://www.onemap.gov.sg/docs/) |
| Geospatial | Childcare Services | .geojson | [Hands-on Ex 3](https://annatrw-is415.netlify.app/hands-on_ex/hands-on_ex03/hands-on_ex03) |
| Geospatial | Bus Stops | .shp | [Datamall](https://datamall.lta.gov.sg/content/dam/datamall/datasets/Geospatial/BusStopLocation.zip) |
| Geospatial | Primary Schools | .xlsx | [data.gov.sg](https://data.gov.sg/dataset/school-directory-and-information) |









